package com.crm.model.entity.returnMoney;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BankFlowExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BankFlowExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFlowIdIsNull() {
            addCriterion("flow_id is null");
            return (Criteria) this;
        }

        public Criteria andFlowIdIsNotNull() {
            addCriterion("flow_id is not null");
            return (Criteria) this;
        }

        public Criteria andFlowIdEqualTo(String value) {
            addCriterion("flow_id =", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdNotEqualTo(String value) {
            addCriterion("flow_id <>", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdGreaterThan(String value) {
            addCriterion("flow_id >", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdGreaterThanOrEqualTo(String value) {
            addCriterion("flow_id >=", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdLessThan(String value) {
            addCriterion("flow_id <", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdLessThanOrEqualTo(String value) {
            addCriterion("flow_id <=", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdLike(String value) {
            addCriterion("flow_id like", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdNotLike(String value) {
            addCriterion("flow_id not like", value, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdIn(List<String> values) {
            addCriterion("flow_id in", values, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdNotIn(List<String> values) {
            addCriterion("flow_id not in", values, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdBetween(String value1, String value2) {
            addCriterion("flow_id between", value1, value2, "flowId");
            return (Criteria) this;
        }

        public Criteria andFlowIdNotBetween(String value1, String value2) {
            addCriterion("flow_id not between", value1, value2, "flowId");
            return (Criteria) this;
        }

        public Criteria andTransactionNoIsNull() {
            addCriterion("transaction_no is null");
            return (Criteria) this;
        }

        public Criteria andTransactionNoIsNotNull() {
            addCriterion("transaction_no is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionNoEqualTo(String value) {
            addCriterion("transaction_no =", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoNotEqualTo(String value) {
            addCriterion("transaction_no <>", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoGreaterThan(String value) {
            addCriterion("transaction_no >", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoGreaterThanOrEqualTo(String value) {
            addCriterion("transaction_no >=", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoLessThan(String value) {
            addCriterion("transaction_no <", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoLessThanOrEqualTo(String value) {
            addCriterion("transaction_no <=", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoLike(String value) {
            addCriterion("transaction_no like", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoNotLike(String value) {
            addCriterion("transaction_no not like", value, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoIn(List<String> values) {
            addCriterion("transaction_no in", values, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoNotIn(List<String> values) {
            addCriterion("transaction_no not in", values, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoBetween(String value1, String value2) {
            addCriterion("transaction_no between", value1, value2, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionNoNotBetween(String value1, String value2) {
            addCriterion("transaction_no not between", value1, value2, "transactionNo");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIsNull() {
            addCriterion("transaction_date is null");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIsNotNull() {
            addCriterion("transaction_date is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionDateEqualTo(String value) {
            addCriterion("transaction_date =", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotEqualTo(String value) {
            addCriterion("transaction_date <>", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateGreaterThan(String value) {
            addCriterion("transaction_date >", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateGreaterThanOrEqualTo(String value) {
            addCriterion("transaction_date >=", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateLessThan(String value) {
            addCriterion("transaction_date <", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateLessThanOrEqualTo(String value) {
            addCriterion("transaction_date <=", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateLike(String value) {
            addCriterion("transaction_date like", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotLike(String value) {
            addCriterion("transaction_date not like", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIn(List<String> values) {
            addCriterion("transaction_date in", values, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotIn(List<String> values) {
            addCriterion("transaction_date not in", values, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateBetween(String value1, String value2) {
            addCriterion("transaction_date between", value1, value2, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotBetween(String value1, String value2) {
            addCriterion("transaction_date not between", value1, value2, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andAbstractsIsNull() {
            addCriterion("abstracts is null");
            return (Criteria) this;
        }

        public Criteria andAbstractsIsNotNull() {
            addCriterion("abstracts is not null");
            return (Criteria) this;
        }

        public Criteria andAbstractsEqualTo(String value) {
            addCriterion("abstracts =", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsNotEqualTo(String value) {
            addCriterion("abstracts <>", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsGreaterThan(String value) {
            addCriterion("abstracts >", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsGreaterThanOrEqualTo(String value) {
            addCriterion("abstracts >=", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsLessThan(String value) {
            addCriterion("abstracts <", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsLessThanOrEqualTo(String value) {
            addCriterion("abstracts <=", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsLike(String value) {
            addCriterion("abstracts like", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsNotLike(String value) {
            addCriterion("abstracts not like", value, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsIn(List<String> values) {
            addCriterion("abstracts in", values, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsNotIn(List<String> values) {
            addCriterion("abstracts not in", values, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsBetween(String value1, String value2) {
            addCriterion("abstracts between", value1, value2, "abstracts");
            return (Criteria) this;
        }

        public Criteria andAbstractsNotBetween(String value1, String value2) {
            addCriterion("abstracts not between", value1, value2, "abstracts");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountIsNull() {
            addCriterion("payee_acount is null");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountIsNotNull() {
            addCriterion("payee_acount is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountEqualTo(String value) {
            addCriterion("payee_acount =", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountNotEqualTo(String value) {
            addCriterion("payee_acount <>", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountGreaterThan(String value) {
            addCriterion("payee_acount >", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountGreaterThanOrEqualTo(String value) {
            addCriterion("payee_acount >=", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountLessThan(String value) {
            addCriterion("payee_acount <", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountLessThanOrEqualTo(String value) {
            addCriterion("payee_acount <=", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountLike(String value) {
            addCriterion("payee_acount like", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountNotLike(String value) {
            addCriterion("payee_acount not like", value, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountIn(List<String> values) {
            addCriterion("payee_acount in", values, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountNotIn(List<String> values) {
            addCriterion("payee_acount not in", values, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountBetween(String value1, String value2) {
            addCriterion("payee_acount between", value1, value2, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeAcountNotBetween(String value1, String value2) {
            addCriterion("payee_acount not between", value1, value2, "payeeAcount");
            return (Criteria) this;
        }

        public Criteria andPayeeNameIsNull() {
            addCriterion("payee_name is null");
            return (Criteria) this;
        }

        public Criteria andPayeeNameIsNotNull() {
            addCriterion("payee_name is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeNameEqualTo(String value) {
            addCriterion("payee_name =", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotEqualTo(String value) {
            addCriterion("payee_name <>", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameGreaterThan(String value) {
            addCriterion("payee_name >", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameGreaterThanOrEqualTo(String value) {
            addCriterion("payee_name >=", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameLessThan(String value) {
            addCriterion("payee_name <", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameLessThanOrEqualTo(String value) {
            addCriterion("payee_name <=", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameLike(String value) {
            addCriterion("payee_name like", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotLike(String value) {
            addCriterion("payee_name not like", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameIn(List<String> values) {
            addCriterion("payee_name in", values, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotIn(List<String> values) {
            addCriterion("payee_name not in", values, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameBetween(String value1, String value2) {
            addCriterion("payee_name between", value1, value2, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotBetween(String value1, String value2) {
            addCriterion("payee_name not between", value1, value2, "payeeName");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyIsNull() {
            addCriterion("opposite_company is null");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyIsNotNull() {
            addCriterion("opposite_company is not null");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyEqualTo(String value) {
            addCriterion("opposite_company =", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyNotEqualTo(String value) {
            addCriterion("opposite_company <>", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyGreaterThan(String value) {
            addCriterion("opposite_company >", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("opposite_company >=", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyLessThan(String value) {
            addCriterion("opposite_company <", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyLessThanOrEqualTo(String value) {
            addCriterion("opposite_company <=", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyLike(String value) {
            addCriterion("opposite_company like", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyNotLike(String value) {
            addCriterion("opposite_company not like", value, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyIn(List<String> values) {
            addCriterion("opposite_company in", values, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyNotIn(List<String> values) {
            addCriterion("opposite_company not in", values, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyBetween(String value1, String value2) {
            addCriterion("opposite_company between", value1, value2, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeCompanyNotBetween(String value1, String value2) {
            addCriterion("opposite_company not between", value1, value2, "oppositeCompany");
            return (Criteria) this;
        }

        public Criteria andOppositeBankIsNull() {
            addCriterion("opposite_bank is null");
            return (Criteria) this;
        }

        public Criteria andOppositeBankIsNotNull() {
            addCriterion("opposite_bank is not null");
            return (Criteria) this;
        }

        public Criteria andOppositeBankEqualTo(String value) {
            addCriterion("opposite_bank =", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankNotEqualTo(String value) {
            addCriterion("opposite_bank <>", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankGreaterThan(String value) {
            addCriterion("opposite_bank >", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankGreaterThanOrEqualTo(String value) {
            addCriterion("opposite_bank >=", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankLessThan(String value) {
            addCriterion("opposite_bank <", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankLessThanOrEqualTo(String value) {
            addCriterion("opposite_bank <=", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankLike(String value) {
            addCriterion("opposite_bank like", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankNotLike(String value) {
            addCriterion("opposite_bank not like", value, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankIn(List<String> values) {
            addCriterion("opposite_bank in", values, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankNotIn(List<String> values) {
            addCriterion("opposite_bank not in", values, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankBetween(String value1, String value2) {
            addCriterion("opposite_bank between", value1, value2, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankNotBetween(String value1, String value2) {
            addCriterion("opposite_bank not between", value1, value2, "oppositeBank");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountIsNull() {
            addCriterion("opposite_bank_account is null");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountIsNotNull() {
            addCriterion("opposite_bank_account is not null");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountEqualTo(String value) {
            addCriterion("opposite_bank_account =", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountNotEqualTo(String value) {
            addCriterion("opposite_bank_account <>", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountGreaterThan(String value) {
            addCriterion("opposite_bank_account >", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountGreaterThanOrEqualTo(String value) {
            addCriterion("opposite_bank_account >=", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountLessThan(String value) {
            addCriterion("opposite_bank_account <", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountLessThanOrEqualTo(String value) {
            addCriterion("opposite_bank_account <=", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountLike(String value) {
            addCriterion("opposite_bank_account like", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountNotLike(String value) {
            addCriterion("opposite_bank_account not like", value, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountIn(List<String> values) {
            addCriterion("opposite_bank_account in", values, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountNotIn(List<String> values) {
            addCriterion("opposite_bank_account not in", values, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountBetween(String value1, String value2) {
            addCriterion("opposite_bank_account between", value1, value2, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andOppositeBankAccountNotBetween(String value1, String value2) {
            addCriterion("opposite_bank_account not between", value1, value2, "oppositeBankAccount");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyIsNull() {
            addCriterion("credit_money is null");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyIsNotNull() {
            addCriterion("credit_money is not null");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyEqualTo(BigDecimal value) {
            addCriterion("credit_money =", value, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyNotEqualTo(BigDecimal value) {
            addCriterion("credit_money <>", value, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyGreaterThan(BigDecimal value) {
            addCriterion("credit_money >", value, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("credit_money >=", value, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyLessThan(BigDecimal value) {
            addCriterion("credit_money <", value, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("credit_money <=", value, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyIn(List<BigDecimal> values) {
            addCriterion("credit_money in", values, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyNotIn(List<BigDecimal> values) {
            addCriterion("credit_money not in", values, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("credit_money between", value1, value2, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andCreditMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("credit_money not between", value1, value2, "creditMoney");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountIsNull() {
            addCriterion("available_amount is null");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountIsNotNull() {
            addCriterion("available_amount is not null");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountEqualTo(BigDecimal value) {
            addCriterion("available_amount =", value, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountNotEqualTo(BigDecimal value) {
            addCriterion("available_amount <>", value, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountGreaterThan(BigDecimal value) {
            addCriterion("available_amount >", value, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("available_amount >=", value, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountLessThan(BigDecimal value) {
            addCriterion("available_amount <", value, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("available_amount <=", value, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountIn(List<BigDecimal> values) {
            addCriterion("available_amount in", values, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountNotIn(List<BigDecimal> values) {
            addCriterion("available_amount not in", values, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("available_amount between", value1, value2, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andAvailableAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("available_amount not between", value1, value2, "availableAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountIsNull() {
            addCriterion("used_amount is null");
            return (Criteria) this;
        }

        public Criteria andUsedAmountIsNotNull() {
            addCriterion("used_amount is not null");
            return (Criteria) this;
        }

        public Criteria andUsedAmountEqualTo(BigDecimal value) {
            addCriterion("used_amount =", value, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountNotEqualTo(BigDecimal value) {
            addCriterion("used_amount <>", value, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountGreaterThan(BigDecimal value) {
            addCriterion("used_amount >", value, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("used_amount >=", value, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountLessThan(BigDecimal value) {
            addCriterion("used_amount <", value, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("used_amount <=", value, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountIn(List<BigDecimal> values) {
            addCriterion("used_amount in", values, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountNotIn(List<BigDecimal> values) {
            addCriterion("used_amount not in", values, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("used_amount between", value1, value2, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andUsedAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("used_amount not between", value1, value2, "usedAmount");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameIsNull() {
            addCriterion("create_people_name is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameIsNotNull() {
            addCriterion("create_people_name is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameEqualTo(String value) {
            addCriterion("create_people_name =", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameNotEqualTo(String value) {
            addCriterion("create_people_name <>", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameGreaterThan(String value) {
            addCriterion("create_people_name >", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_name >=", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameLessThan(String value) {
            addCriterion("create_people_name <", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameLessThanOrEqualTo(String value) {
            addCriterion("create_people_name <=", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameLike(String value) {
            addCriterion("create_people_name like", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameNotLike(String value) {
            addCriterion("create_people_name not like", value, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameIn(List<String> values) {
            addCriterion("create_people_name in", values, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameNotIn(List<String> values) {
            addCriterion("create_people_name not in", values, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameBetween(String value1, String value2) {
            addCriterion("create_people_name between", value1, value2, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleNameNotBetween(String value1, String value2) {
            addCriterion("create_people_name not between", value1, value2, "createPeopleName");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNull() {
            addCriterion("company_id is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNotNull() {
            addCriterion("company_id is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdEqualTo(String value) {
            addCriterion("company_id =", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotEqualTo(String value) {
            addCriterion("company_id <>", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThan(String value) {
            addCriterion("company_id >", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThanOrEqualTo(String value) {
            addCriterion("company_id >=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThan(String value) {
            addCriterion("company_id <", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThanOrEqualTo(String value) {
            addCriterion("company_id <=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLike(String value) {
            addCriterion("company_id like", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotLike(String value) {
            addCriterion("company_id not like", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIn(List<String> values) {
            addCriterion("company_id in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotIn(List<String> values) {
            addCriterion("company_id not in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdBetween(String value1, String value2) {
            addCriterion("company_id between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotBetween(String value1, String value2) {
            addCriterion("company_id not between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andRelationStateIsNull() {
            addCriterion("relation_state is null");
            return (Criteria) this;
        }

        public Criteria andRelationStateIsNotNull() {
            addCriterion("relation_state is not null");
            return (Criteria) this;
        }

        public Criteria andRelationStateEqualTo(String value) {
            addCriterion("relation_state =", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateNotEqualTo(String value) {
            addCriterion("relation_state <>", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateGreaterThan(String value) {
            addCriterion("relation_state >", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateGreaterThanOrEqualTo(String value) {
            addCriterion("relation_state >=", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateLessThan(String value) {
            addCriterion("relation_state <", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateLessThanOrEqualTo(String value) {
            addCriterion("relation_state <=", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateLike(String value) {
            addCriterion("relation_state like", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateNotLike(String value) {
            addCriterion("relation_state not like", value, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateIn(List<String> values) {
            addCriterion("relation_state in", values, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateNotIn(List<String> values) {
            addCriterion("relation_state not in", values, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateBetween(String value1, String value2) {
            addCriterion("relation_state between", value1, value2, "relationState");
            return (Criteria) this;
        }

        public Criteria andRelationStateNotBetween(String value1, String value2) {
            addCriterion("relation_state not between", value1, value2, "relationState");
            return (Criteria) this;
        }

        public Criteria andOperateFlagIsNull() {
            addCriterion("operate_flag is null");
            return (Criteria) this;
        }

        public Criteria andOperateFlagIsNotNull() {
            addCriterion("operate_flag is not null");
            return (Criteria) this;
        }

        public Criteria andOperateFlagEqualTo(String value) {
            addCriterion("operate_flag =", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagNotEqualTo(String value) {
            addCriterion("operate_flag <>", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagGreaterThan(String value) {
            addCriterion("operate_flag >", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagGreaterThanOrEqualTo(String value) {
            addCriterion("operate_flag >=", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagLessThan(String value) {
            addCriterion("operate_flag <", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagLessThanOrEqualTo(String value) {
            addCriterion("operate_flag <=", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagLike(String value) {
            addCriterion("operate_flag like", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagNotLike(String value) {
            addCriterion("operate_flag not like", value, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagIn(List<String> values) {
            addCriterion("operate_flag in", values, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagNotIn(List<String> values) {
            addCriterion("operate_flag not in", values, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagBetween(String value1, String value2) {
            addCriterion("operate_flag between", value1, value2, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andOperateFlagNotBetween(String value1, String value2) {
            addCriterion("operate_flag not between", value1, value2, "operateFlag");
            return (Criteria) this;
        }

        public Criteria andRowNumberIsNull() {
            addCriterion("row_number is null");
            return (Criteria) this;
        }

        public Criteria andRowNumberIsNotNull() {
            addCriterion("row_number is not null");
            return (Criteria) this;
        }

        public Criteria andRowNumberEqualTo(Integer value) {
            addCriterion("row_number =", value, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberNotEqualTo(Integer value) {
            addCriterion("row_number <>", value, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberGreaterThan(Integer value) {
            addCriterion("row_number >", value, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("row_number >=", value, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberLessThan(Integer value) {
            addCriterion("row_number <", value, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberLessThanOrEqualTo(Integer value) {
            addCriterion("row_number <=", value, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberIn(List<Integer> values) {
            addCriterion("row_number in", values, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberNotIn(List<Integer> values) {
            addCriterion("row_number not in", values, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberBetween(Integer value1, Integer value2) {
            addCriterion("row_number between", value1, value2, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andRowNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("row_number not between", value1, value2, "rowNumber");
            return (Criteria) this;
        }

        public Criteria andBatchNoIsNull() {
            addCriterion("batch_no is null");
            return (Criteria) this;
        }

        public Criteria andBatchNoIsNotNull() {
            addCriterion("batch_no is not null");
            return (Criteria) this;
        }

        public Criteria andBatchNoEqualTo(Integer value) {
            addCriterion("batch_no =", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoNotEqualTo(Integer value) {
            addCriterion("batch_no <>", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoGreaterThan(Integer value) {
            addCriterion("batch_no >", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("batch_no >=", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoLessThan(Integer value) {
            addCriterion("batch_no <", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoLessThanOrEqualTo(Integer value) {
            addCriterion("batch_no <=", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoIn(List<Integer> values) {
            addCriterion("batch_no in", values, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoNotIn(List<Integer> values) {
            addCriterion("batch_no not in", values, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoBetween(Integer value1, Integer value2) {
            addCriterion("batch_no between", value1, value2, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoNotBetween(Integer value1, Integer value2) {
            addCriterion("batch_no not between", value1, value2, "batchNo");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}